package org.cornland.systemWarning.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.cornland.systemWarning.model.RealdataTag;

import java.util.List;

/**
 * <p>
 * 实时数据解析点位配置表 Mapper 接口
 * </p>
 *
 * @author Hawk Tang
 * @since 2021-11-02
*/

@Mapper
public interface RealdataTagMapper extends BaseMapper<RealdataTag> {

    // 取得所有井带状态点位信息
    @Select("SELECT well_id,status_tag,jmjh FROM realdata_tag t1 " +
            "left join well t2 on t1.well_id = t2.id ")
    List<RealdataTag> getExistControllerTag();
}